package com.ecoolex.discount.sales.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class YWCardInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public YWCardInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public YWCardInfoExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public YWCardInfoExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        YWCardInfoExample example = new YWCardInfoExample();
        return example.createCriteria();
    }

    public YWCardInfoExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public YWCardInfoExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public YWCardInfoExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public YWCardInfoExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public YWCardInfoExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ywcardinfo.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ywcardinfo.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ywcardinfo.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ywcardinfo.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ywcardinfo.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywcardinfo.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ywcardinfo.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ywcardinfo.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ywcardinfo.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ywcardinfo.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ywcardinfo.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ywcardinfo.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNull() {
            addCriterion("ywcardinfo.ChannelId is null");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNotNull() {
            addCriterion("ywcardinfo.ChannelId is not null");
            return (Criteria) this;
        }

        public Criteria andChannelIdEqualTo(String value) {
            addCriterion("ywcardinfo.ChannelId =", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ChannelId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdNotEqualTo(String value) {
            addCriterion("ywcardinfo.ChannelId <>", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ChannelId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThan(String value) {
            addCriterion("ywcardinfo.ChannelId >", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ChannelId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.ChannelId >=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ChannelId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThan(String value) {
            addCriterion("ywcardinfo.ChannelId <", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ChannelId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.ChannelId <=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ChannelId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andChannelIdLike(String value) {
            addCriterion("ywcardinfo.ChannelId like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotLike(String value) {
            addCriterion("ywcardinfo.ChannelId not like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdIn(List<String> values) {
            addCriterion("ywcardinfo.ChannelId in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotIn(List<String> values) {
            addCriterion("ywcardinfo.ChannelId not in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdBetween(String value1, String value2) {
            addCriterion("ywcardinfo.ChannelId between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.ChannelId not between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andServiceIdIsNull() {
            addCriterion("ywcardinfo.ServiceId is null");
            return (Criteria) this;
        }

        public Criteria andServiceIdIsNotNull() {
            addCriterion("ywcardinfo.ServiceId is not null");
            return (Criteria) this;
        }

        public Criteria andServiceIdEqualTo(String value) {
            addCriterion("ywcardinfo.ServiceId =", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ServiceId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdNotEqualTo(String value) {
            addCriterion("ywcardinfo.ServiceId <>", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ServiceId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThan(String value) {
            addCriterion("ywcardinfo.ServiceId >", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ServiceId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.ServiceId >=", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ServiceId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThan(String value) {
            addCriterion("ywcardinfo.ServiceId <", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ServiceId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.ServiceId <=", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.ServiceId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceIdLike(String value) {
            addCriterion("ywcardinfo.ServiceId like", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotLike(String value) {
            addCriterion("ywcardinfo.ServiceId not like", value, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdIn(List<String> values) {
            addCriterion("ywcardinfo.ServiceId in", values, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotIn(List<String> values) {
            addCriterion("ywcardinfo.ServiceId not in", values, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdBetween(String value1, String value2) {
            addCriterion("ywcardinfo.ServiceId between", value1, value2, "serviceId");
            return (Criteria) this;
        }

        public Criteria andServiceIdNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.ServiceId not between", value1, value2, "serviceId");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoIsNull() {
            addCriterion("ywcardinfo.YouworldOrderNo is null");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoIsNotNull() {
            addCriterion("ywcardinfo.YouworldOrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoEqualTo(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo =", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.YouworldOrderNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoNotEqualTo(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo <>", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.YouworldOrderNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoGreaterThan(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo >", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.YouworldOrderNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo >=", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.YouworldOrderNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoLessThan(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo <", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.YouworldOrderNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo <=", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.YouworldOrderNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoLike(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo like", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoNotLike(String value) {
            addCriterion("ywcardinfo.YouworldOrderNo not like", value, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoIn(List<String> values) {
            addCriterion("ywcardinfo.YouworldOrderNo in", values, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoNotIn(List<String> values) {
            addCriterion("ywcardinfo.YouworldOrderNo not in", values, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoBetween(String value1, String value2) {
            addCriterion("ywcardinfo.YouworldOrderNo between", value1, value2, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andYouworldOrderNoNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.YouworldOrderNo not between", value1, value2, "youworldOrderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("ywcardinfo.OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("ywcardinfo.OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("ywcardinfo.OrderNo =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.OrderNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("ywcardinfo.OrderNo <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.OrderNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("ywcardinfo.OrderNo >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.OrderNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.OrderNo >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.OrderNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("ywcardinfo.OrderNo <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.OrderNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.OrderNo <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.OrderNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("ywcardinfo.OrderNo like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("ywcardinfo.OrderNo not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("ywcardinfo.OrderNo in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("ywcardinfo.OrderNo not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("ywcardinfo.OrderNo between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.OrderNo not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andFaceValueIsNull() {
            addCriterion("ywcardinfo.FaceValue is null");
            return (Criteria) this;
        }

        public Criteria andFaceValueIsNotNull() {
            addCriterion("ywcardinfo.FaceValue is not null");
            return (Criteria) this;
        }

        public Criteria andFaceValueEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.FaceValue =", value, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.FaceValue = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFaceValueNotEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.FaceValue <>", value, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.FaceValue <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFaceValueGreaterThan(BigDecimal value) {
            addCriterion("ywcardinfo.FaceValue >", value, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.FaceValue > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFaceValueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.FaceValue >=", value, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.FaceValue >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFaceValueLessThan(BigDecimal value) {
            addCriterion("ywcardinfo.FaceValue <", value, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.FaceValue < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFaceValueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.FaceValue <=", value, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.FaceValue <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFaceValueIn(List<BigDecimal> values) {
            addCriterion("ywcardinfo.FaceValue in", values, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueNotIn(List<BigDecimal> values) {
            addCriterion("ywcardinfo.FaceValue not in", values, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywcardinfo.FaceValue between", value1, value2, "faceValue");
            return (Criteria) this;
        }

        public Criteria andFaceValueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywcardinfo.FaceValue not between", value1, value2, "faceValue");
            return (Criteria) this;
        }

        public Criteria andCardIdIsNull() {
            addCriterion("ywcardinfo.CardId is null");
            return (Criteria) this;
        }

        public Criteria andCardIdIsNotNull() {
            addCriterion("ywcardinfo.CardId is not null");
            return (Criteria) this;
        }

        public Criteria andCardIdEqualTo(Integer value) {
            addCriterion("ywcardinfo.CardId =", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdNotEqualTo(Integer value) {
            addCriterion("ywcardinfo.CardId <>", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThan(Integer value) {
            addCriterion("ywcardinfo.CardId >", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywcardinfo.CardId >=", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdLessThan(Integer value) {
            addCriterion("ywcardinfo.CardId <", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanOrEqualTo(Integer value) {
            addCriterion("ywcardinfo.CardId <=", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardIdIn(List<Integer> values) {
            addCriterion("ywcardinfo.CardId in", values, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotIn(List<Integer> values) {
            addCriterion("ywcardinfo.CardId not in", values, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdBetween(Integer value1, Integer value2) {
            addCriterion("ywcardinfo.CardId between", value1, value2, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ywcardinfo.CardId not between", value1, value2, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardNameIsNull() {
            addCriterion("ywcardinfo.CardName is null");
            return (Criteria) this;
        }

        public Criteria andCardNameIsNotNull() {
            addCriterion("ywcardinfo.CardName is not null");
            return (Criteria) this;
        }

        public Criteria andCardNameEqualTo(String value) {
            addCriterion("ywcardinfo.CardName =", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardName = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardNameNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardName <>", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardName <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardNameGreaterThan(String value) {
            addCriterion("ywcardinfo.CardName >", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardName > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardNameGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardName >=", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardName >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardNameLessThan(String value) {
            addCriterion("ywcardinfo.CardName <", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardName < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardNameLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardName <=", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardName <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardNameLike(String value) {
            addCriterion("ywcardinfo.CardName like", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotLike(String value) {
            addCriterion("ywcardinfo.CardName not like", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameIn(List<String> values) {
            addCriterion("ywcardinfo.CardName in", values, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardName not in", values, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardName between", value1, value2, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardName not between", value1, value2, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberIsNull() {
            addCriterion("ywcardinfo.CardBarcodeNumber is null");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberIsNotNull() {
            addCriterion("ywcardinfo.CardBarcodeNumber is not null");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber =", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber <>", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberGreaterThan(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber >", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber >=", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberLessThan(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber <", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber <=", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberLike(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber like", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberNotLike(String value) {
            addCriterion("ywcardinfo.CardBarcodeNumber not like", value, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberIn(List<String> values) {
            addCriterion("ywcardinfo.CardBarcodeNumber in", values, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardBarcodeNumber not in", values, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardBarcodeNumber between", value1, value2, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeNumberNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardBarcodeNumber not between", value1, value2, "cardBarcodeNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberIsNull() {
            addCriterion("ywcardinfo.CardPinNumber is null");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberIsNotNull() {
            addCriterion("ywcardinfo.CardPinNumber is not null");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberEqualTo(String value) {
            addCriterion("ywcardinfo.CardPinNumber =", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardPinNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardPinNumberNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardPinNumber <>", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardPinNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardPinNumberGreaterThan(String value) {
            addCriterion("ywcardinfo.CardPinNumber >", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardPinNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardPinNumberGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardPinNumber >=", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardPinNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardPinNumberLessThan(String value) {
            addCriterion("ywcardinfo.CardPinNumber <", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardPinNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardPinNumberLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardPinNumber <=", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardPinNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardPinNumberLike(String value) {
            addCriterion("ywcardinfo.CardPinNumber like", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberNotLike(String value) {
            addCriterion("ywcardinfo.CardPinNumber not like", value, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberIn(List<String> values) {
            addCriterion("ywcardinfo.CardPinNumber in", values, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardPinNumber not in", values, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardPinNumber between", value1, value2, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardPinNumberNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardPinNumber not between", value1, value2, "cardPinNumber");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgIsNull() {
            addCriterion("ywcardinfo.CardBarcodeImg is null");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgIsNotNull() {
            addCriterion("ywcardinfo.CardBarcodeImg is not null");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg =", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeImg = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg <>", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeImg <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgGreaterThan(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg >", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeImg > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg >=", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeImg >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgLessThan(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg <", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeImg < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg <=", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardBarcodeImg <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgLike(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg like", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgNotLike(String value) {
            addCriterion("ywcardinfo.CardBarcodeImg not like", value, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgIn(List<String> values) {
            addCriterion("ywcardinfo.CardBarcodeImg in", values, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardBarcodeImg not in", values, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardBarcodeImg between", value1, value2, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardBarcodeImgNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardBarcodeImg not between", value1, value2, "cardBarcodeImg");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkIsNull() {
            addCriterion("ywcardinfo.CardCertificateLink is null");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkIsNotNull() {
            addCriterion("ywcardinfo.CardCertificateLink is not null");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkEqualTo(String value) {
            addCriterion("ywcardinfo.CardCertificateLink =", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardCertificateLink = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardCertificateLink <>", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardCertificateLink <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkGreaterThan(String value) {
            addCriterion("ywcardinfo.CardCertificateLink >", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardCertificateLink > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardCertificateLink >=", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardCertificateLink >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkLessThan(String value) {
            addCriterion("ywcardinfo.CardCertificateLink <", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardCertificateLink < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardCertificateLink <=", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardCertificateLink <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkLike(String value) {
            addCriterion("ywcardinfo.CardCertificateLink like", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkNotLike(String value) {
            addCriterion("ywcardinfo.CardCertificateLink not like", value, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkIn(List<String> values) {
            addCriterion("ywcardinfo.CardCertificateLink in", values, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardCertificateLink not in", values, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardCertificateLink between", value1, value2, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardCertificateLinkNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardCertificateLink not between", value1, value2, "cardCertificateLink");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlIsNull() {
            addCriterion("ywcardinfo.CardLogoUrl is null");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlIsNotNull() {
            addCriterion("ywcardinfo.CardLogoUrl is not null");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlEqualTo(String value) {
            addCriterion("ywcardinfo.CardLogoUrl =", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardLogoUrl = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardLogoUrl <>", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardLogoUrl <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlGreaterThan(String value) {
            addCriterion("ywcardinfo.CardLogoUrl >", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardLogoUrl > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardLogoUrl >=", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardLogoUrl >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlLessThan(String value) {
            addCriterion("ywcardinfo.CardLogoUrl <", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardLogoUrl < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardLogoUrl <=", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardLogoUrl <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlLike(String value) {
            addCriterion("ywcardinfo.CardLogoUrl like", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlNotLike(String value) {
            addCriterion("ywcardinfo.CardLogoUrl not like", value, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlIn(List<String> values) {
            addCriterion("ywcardinfo.CardLogoUrl in", values, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardLogoUrl not in", values, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardLogoUrl between", value1, value2, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardLogoUrlNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardLogoUrl not between", value1, value2, "cardLogoUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlIsNull() {
            addCriterion("ywcardinfo.CardImageUrl is null");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlIsNotNull() {
            addCriterion("ywcardinfo.CardImageUrl is not null");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlEqualTo(String value) {
            addCriterion("ywcardinfo.CardImageUrl =", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardImageUrl = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardImageUrlNotEqualTo(String value) {
            addCriterion("ywcardinfo.CardImageUrl <>", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardImageUrl <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardImageUrlGreaterThan(String value) {
            addCriterion("ywcardinfo.CardImageUrl >", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardImageUrl > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardImageUrlGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardImageUrl >=", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardImageUrl >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardImageUrlLessThan(String value) {
            addCriterion("ywcardinfo.CardImageUrl <", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardImageUrl < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardImageUrlLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.CardImageUrl <=", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardImageUrl <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardImageUrlLike(String value) {
            addCriterion("ywcardinfo.CardImageUrl like", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlNotLike(String value) {
            addCriterion("ywcardinfo.CardImageUrl not like", value, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlIn(List<String> values) {
            addCriterion("ywcardinfo.CardImageUrl in", values, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlNotIn(List<String> values) {
            addCriterion("ywcardinfo.CardImageUrl not in", values, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardImageUrl between", value1, value2, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardImageUrlNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.CardImageUrl not between", value1, value2, "cardImageUrl");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentIsNull() {
            addCriterion("ywcardinfo.CardDiscountPercent is null");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentIsNotNull() {
            addCriterion("ywcardinfo.CardDiscountPercent is not null");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.CardDiscountPercent =", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardDiscountPercent = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.CardDiscountPercent <>", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardDiscountPercent <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThan(BigDecimal value) {
            addCriterion("ywcardinfo.CardDiscountPercent >", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardDiscountPercent > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.CardDiscountPercent >=", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardDiscountPercent >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThan(BigDecimal value) {
            addCriterion("ywcardinfo.CardDiscountPercent <", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardDiscountPercent < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ywcardinfo.CardDiscountPercent <=", value, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CardDiscountPercent <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentIn(List<BigDecimal> values) {
            addCriterion("ywcardinfo.CardDiscountPercent in", values, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotIn(List<BigDecimal> values) {
            addCriterion("ywcardinfo.CardDiscountPercent not in", values, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywcardinfo.CardDiscountPercent between", value1, value2, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCardDiscountPercentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ywcardinfo.CardDiscountPercent not between", value1, value2, "cardDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("ywcardinfo.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("ywcardinfo.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("ywcardinfo.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("ywcardinfo.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("ywcardinfo.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ywcardinfo.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("ywcardinfo.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("ywcardinfo.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("ywcardinfo.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("ywcardinfo.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("ywcardinfo.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ywcardinfo.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("ywcardinfo.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("ywcardinfo.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("ywcardinfo.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("ywcardinfo.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("ywcardinfo.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("ywcardinfo.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("ywcardinfo.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("ywcardinfo.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("ywcardinfo.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("ywcardinfo.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("ywcardinfo.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("ywcardinfo.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("ywcardinfo.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("ywcardinfo.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("ywcardinfo.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("ywcardinfo.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("ywcardinfo.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("ywcardinfo.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("ywcardinfo.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("ywcardinfo.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("ywcardinfo.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("ywcardinfo.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("ywcardinfo.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("ywcardinfo.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("ywcardinfo.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("ywcardinfo.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("ywcardinfo.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("ywcardinfo.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ywcardinfo.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("ywcardinfo.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("ywcardinfo.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("ywcardinfo.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("ywcardinfo.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("ywcardinfo.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("ywcardinfo.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("ywcardinfo.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("ywcardinfo.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("ywcardinfo.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("ywcardinfo.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("ywcardinfo.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("ywcardinfo.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("ywcardinfo.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("ywcardinfo.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("ywcardinfo.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("ywcardinfo.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("ywcardinfo.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("ywcardinfo.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("ywcardinfo.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("ywcardinfo.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("ywcardinfo.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("ywcardinfo.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("ywcardinfo.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("ywcardinfo.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ywcardinfo.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("ywcardinfo.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("ywcardinfo.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(YWCardInfo.Column column) {
            addCriterion(new StringBuilder("ywcardinfo.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("ywcardinfo.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("ywcardinfo.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("ywcardinfo.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("ywcardinfo.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private YWCardInfoExample example;

        protected Criteria(YWCardInfoExample example) {
            super();
            this.example = example;
        }

        public YWCardInfoExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(YWCardInfo.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(YWCardInfo.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.discount.sales.entity.YWCardInfoExample example);
    }
}